package com.itheima.mapper;

import com.itheima.domain.insertGame;
import com.itheima.vo.youxiVO;
import org.apache.ibatis.annotations.*;

import java.util.List;
@Mapper
public interface YouxiMapper {

        @Select("SELECT * FROM tb_game")
        public List<youxiVO> selectAll();


        @Insert("insert into tb_game (id,name,type,url,ordered,company)values (#{id},#{name},#{type},#{url},#{ordered},#{company})")
    void lrxx(insertGame intg);


    @Update("UPDATE tb_game SET name = #{name}, type = #{type}, url = #{url}, ordered = #{ordered}, company = #{company} WHERE id = #{id}")
    void xiugai(insertGame intg1);

    @Delete("DELETE FROM tb_game WHERE id = #{id}")
     void chanchu( Integer id);
}

